package com.ruoyi.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ruoyi.cyb.botiancybcredit.pojo.ValuationEntity;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

/**
 * @author 26352
 * @Date 2023/2/24 18:20
 * @Description TODO
 * @Version 1.0
 */
@Mapper
public interface VluationMapper extends BaseMapper<ValuationEntity> {

    @Select("SELECT SUM(v.appraisement) FROM valuation v  GROUP BY v.uid having v.uid =#{uid}")
    Double selectByUid(Integer uid);
}
